About Our Project
With our project partner, The Kellermann Foundation, we are working on a database that helps the employees of the Kellermann Foundation track and keep up with the donations and grants that they receive. The database will allow the employees to see upcoming deadlines for grant applications and generate custom reports according to user specifications, allowing for a filtered analysis. Grants will have subtypes that determine how the grant money will be spent and allocated, giving better organization for the Foundation. The availability of hand-typed comments will also be made possible to provide a better user experience. Alongside grants, the donors will be tracked by obtaining their information (address, website, contact info), to speed up grant acquisition.
What We Did
Over the course of a few months, our team has made a lot of progress. This included engaging with the Kellerman Foundation in August and September, identifying the client’s issues, and learning tools such as SQLite and Node.js. We were able to rework the report system to provide better functionality. In detail, the report system was designed to create custom reports based on the user’s specifications. This allows for a better and more efficient way to generate custom reports. When we got into October, there was a change of focus to the homepage enhancement where we reworked dynamic homepage analytics, enhanced the homepage to display immediate deadlines, and implemented notifications. In November, we shifted towards cleaning up, making our finishing touches, and preparing for the EPICS Expo Exhibit. This included writing documentation and looking for any last-minute bugs. For more detail, please visit project updates.
Skills used/learned to make this happen
To create the database, we had to get comfortable with multiple new skills such as NodeJS, Express Handlebars, SQLite, and JavaScript.
The impact of this project
By creating a system that allows the Foundation to organize its grants by specific designations and different dates such as funds received and deadlines, we hope that this project will significantly help the Foundation expedite the distribution of money correctly to the Batwa community.
